﻿ALTER TABLE [structure].[Item] ADD
CONSTRAINT [FK_Item_Item] FOREIGN KEY ([ParentId]) REFERENCES [structure].[Item] ([Id])


GO
EXEC sp_addextendedproperty N'MS_Description', N'Parent child heirarchy', 'SCHEMA', N'structure', 'TABLE', N'Item', 'CONSTRAINT', N'FK_Item_Item'

